﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DataSetUnusedNonClusteredIndexes" targetNamespace="http://tempuri.org/DataSetUnusedNonClusteredIndexes.xsd" xmlns:mstns="http://tempuri.org/DataSetUnusedNonClusteredIndexes.xsd" xmlns="http://tempuri.org/DataSetUnusedNonClusteredIndexes.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="SQLServerOptimizerConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="SQLServerOptimizerConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.SQLServerOptimizer.PL.WPF.Properties.Settings.GlobalReference.Default.SQLServerOptimizerConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="NonClusteredReportTableAdapter" GeneratorDataComponentClassName="NonClusteredReportTableAdapter" Name="NonClusteredReport" UserDataComponentName="NonClusteredReportTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SQLServerOptimizerConnectionString (Settings)" DbObjectName="SQLServerOptimizer.dbo.NonClusteredReport" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.NonClusteredReport</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IndexID" DataSetColumn="IndexID" />
              <Mapping SourceColumn="TableID" DataSetColumn="TableID" />
              <Mapping SourceColumn="IndexName" DataSetColumn="IndexName" />
              <Mapping SourceColumn="IndexSize" DataSetColumn="IndexSize" />
              <Mapping SourceColumn="Statistics_LastUpdatedDate" DataSetColumn="Statistics_LastUpdatedDate" />
              <Mapping SourceColumn="Fragmentation" DataSetColumn="Fragmentation" />
              <Mapping SourceColumn="IS_PK" DataSetColumn="IS_PK" />
              <Mapping SourceColumn="IndexScans" DataSetColumn="IndexScans" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DataSetUnusedNonClusteredIndexes" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="DataSetUnusedNonClusteredIndexes" msprop:Generator_UserDSName="DataSetUnusedNonClusteredIndexes">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="NonClusteredReport" msprop:Generator_TableClassName="NonClusteredReportDataTable" msprop:Generator_TableVarName="tableNonClusteredReport" msprop:Generator_TablePropName="NonClusteredReport" msprop:Generator_RowDeletingName="NonClusteredReportRowDeleting" msprop:Generator_UserTableName="NonClusteredReport" msprop:Generator_RowChangingName="NonClusteredReportRowChanging" msprop:Generator_RowEvHandlerName="NonClusteredReportRowChangeEventHandler" msprop:Generator_RowDeletedName="NonClusteredReportRowDeleted" msprop:Generator_RowEvArgName="NonClusteredReportRowChangeEvent" msprop:Generator_RowChangedName="NonClusteredReportRowChanged" msprop:Generator_RowClassName="NonClusteredReportRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IndexID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_ColumnVarNameInTable="columnIndexID" msprop:Generator_ColumnPropNameInRow="IndexID" msprop:Generator_ColumnPropNameInTable="IndexIDColumn" msprop:Generator_UserColumnName="IndexID" type="xs:int" />
              <xs:element name="TableID" msprop:Generator_ColumnVarNameInTable="columnTableID" msprop:Generator_ColumnPropNameInRow="TableID" msprop:Generator_ColumnPropNameInTable="TableIDColumn" msprop:Generator_UserColumnName="TableID" type="xs:int" />
              <xs:element name="IndexName" msprop:Generator_ColumnVarNameInTable="columnIndexName" msprop:Generator_ColumnPropNameInRow="IndexName" msprop:Generator_ColumnPropNameInTable="IndexNameColumn" msprop:Generator_UserColumnName="IndexName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IndexSize" msprop:Generator_ColumnVarNameInTable="columnIndexSize" msprop:Generator_ColumnPropNameInRow="IndexSize" msprop:Generator_ColumnPropNameInTable="IndexSizeColumn" msprop:Generator_UserColumnName="IndexSize" type="xs:decimal" minOccurs="0" />
              <xs:element name="Statistics_LastUpdatedDate" msprop:Generator_ColumnVarNameInTable="columnStatistics_LastUpdatedDate" msprop:Generator_ColumnPropNameInRow="Statistics_LastUpdatedDate" msprop:Generator_ColumnPropNameInTable="Statistics_LastUpdatedDateColumn" msprop:Generator_UserColumnName="Statistics_LastUpdatedDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Fragmentation" msprop:Generator_ColumnVarNameInTable="columnFragmentation" msprop:Generator_ColumnPropNameInRow="Fragmentation" msprop:Generator_ColumnPropNameInTable="FragmentationColumn" msprop:Generator_UserColumnName="Fragmentation" type="xs:decimal" minOccurs="0" />
              <xs:element name="IS_PK" msprop:Generator_ColumnVarNameInTable="columnIS_PK" msprop:Generator_ColumnPropNameInRow="IS_PK" msprop:Generator_ColumnPropNameInTable="IS_PKColumn" msprop:Generator_UserColumnName="IS_PK" type="xs:boolean" minOccurs="0" />
              <xs:element name="IndexScans" msprop:Generator_ColumnVarNameInTable="columnIndexScans" msprop:Generator_ColumnPropNameInRow="IndexScans" msprop:Generator_ColumnPropNameInTable="IndexScansColumn" msprop:Generator_UserColumnName="IndexScans" type="xs:long" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:NonClusteredReport" />
      <xs:field xpath="mstns:IndexID" />
    </xs:unique>
  </xs:element>
</xs:schema>